package com.auxgroup.hr.front.dao.repository;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import com.auxgroup.hr.front.dao.domain.PsCPersonalData;

import java.util.List;

/**
 * @author lv-PC
 *
 */
@Repository
public interface PsCPersonalDataRepository
		extends JpaRepository<PsCPersonalData, String>, JpaSpecificationExecutor<PsCPersonalData> {

//	@Query("SELECT A.EMPL_RCD,B.NAME, C.DESCRSHORT, D.DESCRSHORT" +
//			"  FROM PS_CURRENT_JOB    A,  PS_PERSONAL_DATA  B, PS_C_CURR_DEPT_VW C, PS_JOBCODE_TBL_VW D" +
//			" WHERE A.EMPLID = B.EMPLID AND A.SETID_DEPT = C.SETID" +
//			"   AND A.DEPTID = C.DEPTID AND A.SETID_JOBCODE = D.SETID" +
//			"   AND A.JOBCODE = D.JOBCODE")
//	List<Object[]> queryExtInfoByEmplid(String emplid);
	PsCPersonalData findFirstByNationalId(String nationalId);

}